﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Core;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.ComponentModel;

namespace Data.DataGet
{
  public  class _ThongTinGiaBan
    {
      DataProvider ob = new SQLProvider();
      public void Update_ThongTinGiaBan(string MaDT, float GiaBan)
      {
          string SPName = "update_ThongTinGiaBan";
          SqlParameter[] para = new SqlParameter[3];
          para[0] = new SqlParameter("@MaDT_0", MaDT);
          para[1] = new SqlParameter("@MaDT", MaDT);
          para[2] = new SqlParameter("@GiaBan", GiaBan);
          ob.Execute_Modify(SPName, para);
      }
      public DataTable GiaBan(string MaDT)
      {
          DataTable ds = new DataTable();
          string strSQL = "select GiaBan from ThongTinGiaBan where MaDT = '" + MaDT + "'";
          return ds = ob.Execute_Table(strSQL);
      }
    }
}
